create external  table jms_ods.yl_oms_order_mark_dict_hi
(
    id      bigint comment 'id',
    mark_key      string comment '标签key',
    mark_name     string comment '标签名称',
    status        tinyint comment '状态',
    remark        string comment '备注',
    is_delete     tinyint comment '是否已经删除，0 否（未删除）1是（已删除）',
    create_time   TIMESTAMP   comment '创建时间',
    update_time   TIMESTAMP comment '更新时间',
    create_user   string comment '创建人',
    update_user   string comment '更新人',
    sync_big_data tinyint comment '是否同步大数据 0 否 1是',
    description   string comment '描述',
    parent_id     bigint comment '父级id'
)
comment '订单标签配置小时表'
 PARTITIONED BY (
   `dt` string COMMENT '时间分区(yyyy-MM-dd-HH)')
stored as parquet
 LOCATION
   '/dw/hive/jms_ods.db/external/yl_oms_order_mark_dict_hi'
     TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );
